package ylsb.model;

import java.util.ArrayList;
import java.util.List;

public class HaocaiyinjinExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HaocaiyinjinExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andXiangmuidIsNull() {
            addCriterion("xiangmuid is null");
            return (Criteria) this;
        }

        public Criteria andXiangmuidIsNotNull() {
            addCriterion("xiangmuid is not null");
            return (Criteria) this;
        }

        public Criteria andXiangmuidEqualTo(String value) {
            addCriterion("xiangmuid =", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidNotEqualTo(String value) {
            addCriterion("xiangmuid <>", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidGreaterThan(String value) {
            addCriterion("xiangmuid >", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidGreaterThanOrEqualTo(String value) {
            addCriterion("xiangmuid >=", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidLessThan(String value) {
            addCriterion("xiangmuid <", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidLessThanOrEqualTo(String value) {
            addCriterion("xiangmuid <=", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidLike(String value) {
            addCriterion("xiangmuid like", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidNotLike(String value) {
            addCriterion("xiangmuid not like", value, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidIn(List<String> values) {
            addCriterion("xiangmuid in", values, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidNotIn(List<String> values) {
            addCriterion("xiangmuid not in", values, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidBetween(String value1, String value2) {
            addCriterion("xiangmuid between", value1, value2, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andXiangmuidNotBetween(String value1, String value2) {
            addCriterion("xiangmuid not between", value1, value2, "xiangmuid");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengIsNull() {
            addCriterion("keshimingcheng is null");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengIsNotNull() {
            addCriterion("keshimingcheng is not null");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengEqualTo(String value) {
            addCriterion("keshimingcheng =", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengNotEqualTo(String value) {
            addCriterion("keshimingcheng <>", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengGreaterThan(String value) {
            addCriterion("keshimingcheng >", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengGreaterThanOrEqualTo(String value) {
            addCriterion("keshimingcheng >=", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengLessThan(String value) {
            addCriterion("keshimingcheng <", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengLessThanOrEqualTo(String value) {
            addCriterion("keshimingcheng <=", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengLike(String value) {
            addCriterion("keshimingcheng like", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengNotLike(String value) {
            addCriterion("keshimingcheng not like", value, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengIn(List<String> values) {
            addCriterion("keshimingcheng in", values, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengNotIn(List<String> values) {
            addCriterion("keshimingcheng not in", values, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengBetween(String value1, String value2) {
            addCriterion("keshimingcheng between", value1, value2, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andKeshimingchengNotBetween(String value1, String value2) {
            addCriterion("keshimingcheng not between", value1, value2, "keshimingcheng");
            return (Criteria) this;
        }

        public Criteria andPinzhongIsNull() {
            addCriterion("pinzhong is null");
            return (Criteria) this;
        }

        public Criteria andPinzhongIsNotNull() {
            addCriterion("pinzhong is not null");
            return (Criteria) this;
        }

        public Criteria andPinzhongEqualTo(Integer value) {
            addCriterion("pinzhong =", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongNotEqualTo(Integer value) {
            addCriterion("pinzhong <>", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongGreaterThan(Integer value) {
            addCriterion("pinzhong >", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongGreaterThanOrEqualTo(Integer value) {
            addCriterion("pinzhong >=", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongLessThan(Integer value) {
            addCriterion("pinzhong <", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongLessThanOrEqualTo(Integer value) {
            addCriterion("pinzhong <=", value, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongIn(List<Integer> values) {
            addCriterion("pinzhong in", values, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongNotIn(List<Integer> values) {
            addCriterion("pinzhong not in", values, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongBetween(Integer value1, Integer value2) {
            addCriterion("pinzhong between", value1, value2, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinzhongNotBetween(Integer value1, Integer value2) {
            addCriterion("pinzhong not between", value1, value2, "pinzhong");
            return (Criteria) this;
        }

        public Criteria andPinpaiIsNull() {
            addCriterion("pinpai is null");
            return (Criteria) this;
        }

        public Criteria andPinpaiIsNotNull() {
            addCriterion("pinpai is not null");
            return (Criteria) this;
        }

        public Criteria andPinpaiEqualTo(String value) {
            addCriterion("pinpai =", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiNotEqualTo(String value) {
            addCriterion("pinpai <>", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiGreaterThan(String value) {
            addCriterion("pinpai >", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiGreaterThanOrEqualTo(String value) {
            addCriterion("pinpai >=", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiLessThan(String value) {
            addCriterion("pinpai <", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiLessThanOrEqualTo(String value) {
            addCriterion("pinpai <=", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiLike(String value) {
            addCriterion("pinpai like", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiNotLike(String value) {
            addCriterion("pinpai not like", value, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiIn(List<String> values) {
            addCriterion("pinpai in", values, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiNotIn(List<String> values) {
            addCriterion("pinpai not in", values, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiBetween(String value1, String value2) {
            addCriterion("pinpai between", value1, value2, "pinpai");
            return (Criteria) this;
        }

        public Criteria andPinpaiNotBetween(String value1, String value2) {
            addCriterion("pinpai not between", value1, value2, "pinpai");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenIsNull() {
            addCriterion("xinghaochaifen is null");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenIsNotNull() {
            addCriterion("xinghaochaifen is not null");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenEqualTo(String value) {
            addCriterion("xinghaochaifen =", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenNotEqualTo(String value) {
            addCriterion("xinghaochaifen <>", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenGreaterThan(String value) {
            addCriterion("xinghaochaifen >", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenGreaterThanOrEqualTo(String value) {
            addCriterion("xinghaochaifen >=", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenLessThan(String value) {
            addCriterion("xinghaochaifen <", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenLessThanOrEqualTo(String value) {
            addCriterion("xinghaochaifen <=", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenLike(String value) {
            addCriterion("xinghaochaifen like", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenNotLike(String value) {
            addCriterion("xinghaochaifen not like", value, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenIn(List<String> values) {
            addCriterion("xinghaochaifen in", values, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenNotIn(List<String> values) {
            addCriterion("xinghaochaifen not in", values, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenBetween(String value1, String value2) {
            addCriterion("xinghaochaifen between", value1, value2, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andXinghaochaifenNotBetween(String value1, String value2) {
            addCriterion("xinghaochaifen not between", value1, value2, "xinghaochaifen");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaIsNull() {
            addCriterion("pingtaibianma is null");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaIsNotNull() {
            addCriterion("pingtaibianma is not null");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaEqualTo(String value) {
            addCriterion("pingtaibianma =", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaNotEqualTo(String value) {
            addCriterion("pingtaibianma <>", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaGreaterThan(String value) {
            addCriterion("pingtaibianma >", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaGreaterThanOrEqualTo(String value) {
            addCriterion("pingtaibianma >=", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaLessThan(String value) {
            addCriterion("pingtaibianma <", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaLessThanOrEqualTo(String value) {
            addCriterion("pingtaibianma <=", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaLike(String value) {
            addCriterion("pingtaibianma like", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaNotLike(String value) {
            addCriterion("pingtaibianma not like", value, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaIn(List<String> values) {
            addCriterion("pingtaibianma in", values, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaNotIn(List<String> values) {
            addCriterion("pingtaibianma not in", values, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaBetween(String value1, String value2) {
            addCriterion("pingtaibianma between", value1, value2, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andPingtaibianmaNotBetween(String value1, String value2) {
            addCriterion("pingtaibianma not between", value1, value2, "pingtaibianma");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengIsNull() {
            addCriterion("zhucezhengmingcheng is null");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengIsNotNull() {
            addCriterion("zhucezhengmingcheng is not null");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengEqualTo(String value) {
            addCriterion("zhucezhengmingcheng =", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengNotEqualTo(String value) {
            addCriterion("zhucezhengmingcheng <>", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengGreaterThan(String value) {
            addCriterion("zhucezhengmingcheng >", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengGreaterThanOrEqualTo(String value) {
            addCriterion("zhucezhengmingcheng >=", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengLessThan(String value) {
            addCriterion("zhucezhengmingcheng <", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengLessThanOrEqualTo(String value) {
            addCriterion("zhucezhengmingcheng <=", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengLike(String value) {
            addCriterion("zhucezhengmingcheng like", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengNotLike(String value) {
            addCriterion("zhucezhengmingcheng not like", value, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengIn(List<String> values) {
            addCriterion("zhucezhengmingcheng in", values, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengNotIn(List<String> values) {
            addCriterion("zhucezhengmingcheng not in", values, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengBetween(String value1, String value2) {
            addCriterion("zhucezhengmingcheng between", value1, value2, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andZhucezhengmingchengNotBetween(String value1, String value2) {
            addCriterion("zhucezhengmingcheng not between", value1, value2, "zhucezhengmingcheng");
            return (Criteria) this;
        }

        public Criteria andGuigeIsNull() {
            addCriterion("guige is null");
            return (Criteria) this;
        }

        public Criteria andGuigeIsNotNull() {
            addCriterion("guige is not null");
            return (Criteria) this;
        }

        public Criteria andGuigeEqualTo(String value) {
            addCriterion("guige =", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeNotEqualTo(String value) {
            addCriterion("guige <>", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeGreaterThan(String value) {
            addCriterion("guige >", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeGreaterThanOrEqualTo(String value) {
            addCriterion("guige >=", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeLessThan(String value) {
            addCriterion("guige <", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeLessThanOrEqualTo(String value) {
            addCriterion("guige <=", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeLike(String value) {
            addCriterion("guige like", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeNotLike(String value) {
            addCriterion("guige not like", value, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeIn(List<String> values) {
            addCriterion("guige in", values, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeNotIn(List<String> values) {
            addCriterion("guige not in", values, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeBetween(String value1, String value2) {
            addCriterion("guige between", value1, value2, "guige");
            return (Criteria) this;
        }

        public Criteria andGuigeNotBetween(String value1, String value2) {
            addCriterion("guige not between", value1, value2, "guige");
            return (Criteria) this;
        }

        public Criteria andXinghaoIsNull() {
            addCriterion("xinghao is null");
            return (Criteria) this;
        }

        public Criteria andXinghaoIsNotNull() {
            addCriterion("xinghao is not null");
            return (Criteria) this;
        }

        public Criteria andXinghaoEqualTo(String value) {
            addCriterion("xinghao =", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoNotEqualTo(String value) {
            addCriterion("xinghao <>", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoGreaterThan(String value) {
            addCriterion("xinghao >", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoGreaterThanOrEqualTo(String value) {
            addCriterion("xinghao >=", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoLessThan(String value) {
            addCriterion("xinghao <", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoLessThanOrEqualTo(String value) {
            addCriterion("xinghao <=", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoLike(String value) {
            addCriterion("xinghao like", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoNotLike(String value) {
            addCriterion("xinghao not like", value, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoIn(List<String> values) {
            addCriterion("xinghao in", values, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoNotIn(List<String> values) {
            addCriterion("xinghao not in", values, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoBetween(String value1, String value2) {
            addCriterion("xinghao between", value1, value2, "xinghao");
            return (Criteria) this;
        }

        public Criteria andXinghaoNotBetween(String value1, String value2) {
            addCriterion("xinghao not between", value1, value2, "xinghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoIsNull() {
            addCriterion("zhucezhenghao is null");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoIsNotNull() {
            addCriterion("zhucezhenghao is not null");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoEqualTo(String value) {
            addCriterion("zhucezhenghao =", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoNotEqualTo(String value) {
            addCriterion("zhucezhenghao <>", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoGreaterThan(String value) {
            addCriterion("zhucezhenghao >", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoGreaterThanOrEqualTo(String value) {
            addCriterion("zhucezhenghao >=", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoLessThan(String value) {
            addCriterion("zhucezhenghao <", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoLessThanOrEqualTo(String value) {
            addCriterion("zhucezhenghao <=", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoLike(String value) {
            addCriterion("zhucezhenghao like", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoNotLike(String value) {
            addCriterion("zhucezhenghao not like", value, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoIn(List<String> values) {
            addCriterion("zhucezhenghao in", values, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoNotIn(List<String> values) {
            addCriterion("zhucezhenghao not in", values, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoBetween(String value1, String value2) {
            addCriterion("zhucezhenghao between", value1, value2, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andZhucezhenghaoNotBetween(String value1, String value2) {
            addCriterion("zhucezhenghao not between", value1, value2, "zhucezhenghao");
            return (Criteria) this;
        }

        public Criteria andShengchanshangIsNull() {
            addCriterion("shengchanshang is null");
            return (Criteria) this;
        }

        public Criteria andShengchanshangIsNotNull() {
            addCriterion("shengchanshang is not null");
            return (Criteria) this;
        }

        public Criteria andShengchanshangEqualTo(String value) {
            addCriterion("shengchanshang =", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangNotEqualTo(String value) {
            addCriterion("shengchanshang <>", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangGreaterThan(String value) {
            addCriterion("shengchanshang >", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangGreaterThanOrEqualTo(String value) {
            addCriterion("shengchanshang >=", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangLessThan(String value) {
            addCriterion("shengchanshang <", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangLessThanOrEqualTo(String value) {
            addCriterion("shengchanshang <=", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangLike(String value) {
            addCriterion("shengchanshang like", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangNotLike(String value) {
            addCriterion("shengchanshang not like", value, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangIn(List<String> values) {
            addCriterion("shengchanshang in", values, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangNotIn(List<String> values) {
            addCriterion("shengchanshang not in", values, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangBetween(String value1, String value2) {
            addCriterion("shengchanshang between", value1, value2, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andShengchanshangNotBetween(String value1, String value2) {
            addCriterion("shengchanshang not between", value1, value2, "shengchanshang");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiIsNull() {
            addCriterion("jijiadanwei is null");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiIsNotNull() {
            addCriterion("jijiadanwei is not null");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiEqualTo(String value) {
            addCriterion("jijiadanwei =", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiNotEqualTo(String value) {
            addCriterion("jijiadanwei <>", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiGreaterThan(String value) {
            addCriterion("jijiadanwei >", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiGreaterThanOrEqualTo(String value) {
            addCriterion("jijiadanwei >=", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiLessThan(String value) {
            addCriterion("jijiadanwei <", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiLessThanOrEqualTo(String value) {
            addCriterion("jijiadanwei <=", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiLike(String value) {
            addCriterion("jijiadanwei like", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiNotLike(String value) {
            addCriterion("jijiadanwei not like", value, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiIn(List<String> values) {
            addCriterion("jijiadanwei in", values, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiNotIn(List<String> values) {
            addCriterion("jijiadanwei not in", values, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiBetween(String value1, String value2) {
            addCriterion("jijiadanwei between", value1, value2, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andJijiadanweiNotBetween(String value1, String value2) {
            addCriterion("jijiadanwei not between", value1, value2, "jijiadanwei");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangIsNull() {
            addCriterion("pingtaiqingkuang is null");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangIsNotNull() {
            addCriterion("pingtaiqingkuang is not null");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangEqualTo(String value) {
            addCriterion("pingtaiqingkuang =", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangNotEqualTo(String value) {
            addCriterion("pingtaiqingkuang <>", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangGreaterThan(String value) {
            addCriterion("pingtaiqingkuang >", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangGreaterThanOrEqualTo(String value) {
            addCriterion("pingtaiqingkuang >=", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangLessThan(String value) {
            addCriterion("pingtaiqingkuang <", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangLessThanOrEqualTo(String value) {
            addCriterion("pingtaiqingkuang <=", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangLike(String value) {
            addCriterion("pingtaiqingkuang like", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangNotLike(String value) {
            addCriterion("pingtaiqingkuang not like", value, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangIn(List<String> values) {
            addCriterion("pingtaiqingkuang in", values, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangNotIn(List<String> values) {
            addCriterion("pingtaiqingkuang not in", values, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangBetween(String value1, String value2) {
            addCriterion("pingtaiqingkuang between", value1, value2, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaiqingkuangNotBetween(String value1, String value2) {
            addCriterion("pingtaiqingkuang not between", value1, value2, "pingtaiqingkuang");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaIsNull() {
            addCriterion("pingtaidanjia is null");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaIsNotNull() {
            addCriterion("pingtaidanjia is not null");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaEqualTo(String value) {
            addCriterion("pingtaidanjia =", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaNotEqualTo(String value) {
            addCriterion("pingtaidanjia <>", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaGreaterThan(String value) {
            addCriterion("pingtaidanjia >", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaGreaterThanOrEqualTo(String value) {
            addCriterion("pingtaidanjia >=", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaLessThan(String value) {
            addCriterion("pingtaidanjia <", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaLessThanOrEqualTo(String value) {
            addCriterion("pingtaidanjia <=", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaLike(String value) {
            addCriterion("pingtaidanjia like", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaNotLike(String value) {
            addCriterion("pingtaidanjia not like", value, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaIn(List<String> values) {
            addCriterion("pingtaidanjia in", values, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaNotIn(List<String> values) {
            addCriterion("pingtaidanjia not in", values, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaBetween(String value1, String value2) {
            addCriterion("pingtaidanjia between", value1, value2, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andPingtaidanjiaNotBetween(String value1, String value2) {
            addCriterion("pingtaidanjia not between", value1, value2, "pingtaidanjia");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaIsNull() {
            addCriterion("nanjingshiyibaoma is null");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaIsNotNull() {
            addCriterion("nanjingshiyibaoma is not null");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaEqualTo(String value) {
            addCriterion("nanjingshiyibaoma =", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaNotEqualTo(String value) {
            addCriterion("nanjingshiyibaoma <>", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaGreaterThan(String value) {
            addCriterion("nanjingshiyibaoma >", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaGreaterThanOrEqualTo(String value) {
            addCriterion("nanjingshiyibaoma >=", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaLessThan(String value) {
            addCriterion("nanjingshiyibaoma <", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaLessThanOrEqualTo(String value) {
            addCriterion("nanjingshiyibaoma <=", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaLike(String value) {
            addCriterion("nanjingshiyibaoma like", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaNotLike(String value) {
            addCriterion("nanjingshiyibaoma not like", value, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaIn(List<String> values) {
            addCriterion("nanjingshiyibaoma in", values, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaNotIn(List<String> values) {
            addCriterion("nanjingshiyibaoma not in", values, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaBetween(String value1, String value2) {
            addCriterion("nanjingshiyibaoma between", value1, value2, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andNanjingshiyibaomaNotBetween(String value1, String value2) {
            addCriterion("nanjingshiyibaoma not between", value1, value2, "nanjingshiyibaoma");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuIsNull() {
            addCriterion("gongnengyongtu is null");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuIsNotNull() {
            addCriterion("gongnengyongtu is not null");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuEqualTo(String value) {
            addCriterion("gongnengyongtu =", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuNotEqualTo(String value) {
            addCriterion("gongnengyongtu <>", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuGreaterThan(String value) {
            addCriterion("gongnengyongtu >", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuGreaterThanOrEqualTo(String value) {
            addCriterion("gongnengyongtu >=", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuLessThan(String value) {
            addCriterion("gongnengyongtu <", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuLessThanOrEqualTo(String value) {
            addCriterion("gongnengyongtu <=", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuLike(String value) {
            addCriterion("gongnengyongtu like", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuNotLike(String value) {
            addCriterion("gongnengyongtu not like", value, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuIn(List<String> values) {
            addCriterion("gongnengyongtu in", values, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuNotIn(List<String> values) {
            addCriterion("gongnengyongtu not in", values, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuBetween(String value1, String value2) {
            addCriterion("gongnengyongtu between", value1, value2, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andGongnengyongtuNotBetween(String value1, String value2) {
            addCriterion("gongnengyongtu not between", value1, value2, "gongnengyongtu");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNull() {
            addCriterion("ordernumber is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNotNull() {
            addCriterion("ordernumber is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberEqualTo(Integer value) {
            addCriterion("ordernumber =", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotEqualTo(Integer value) {
            addCriterion("ordernumber <>", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThan(Integer value) {
            addCriterion("ordernumber >", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("ordernumber >=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThan(Integer value) {
            addCriterion("ordernumber <", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThanOrEqualTo(Integer value) {
            addCriterion("ordernumber <=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIn(List<Integer> values) {
            addCriterion("ordernumber in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotIn(List<Integer> values) {
            addCriterion("ordernumber not in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberBetween(Integer value1, Integer value2) {
            addCriterion("ordernumber between", value1, value2, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotBetween(Integer value1, Integer value2) {
            addCriterion("ordernumber not between", value1, value2, "ordernumber");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}